SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_FacultyActivities_Add]
	(
		@param_JOL_FacultyActivities_Faculty NVarChar(50),
		@param_JOL_FacultyActivities_FacultyID VarChar(50) ,
		@param_JOL_FacultyActivities_Type NVarChar(50),
		@param_JOL_FacultyActivities_Title NVarChar(100),
		@param_JOL_FacultyActivities_Site NVarChar(100),
		@param_JOL_FacultyActivities_StartTime DateTime,
		@param_JOL_FacultyActivities_EndTime DateTime,
		@param_JOL_FacultyActivities_Host NVarChar(50),
		@param_JOL_FacultyActivities_Organizers NVarChar(50),
		@param_JOL_FacultyActivities_Participants NVarChar(50),
		@param_JOL_FacultyActivities_Introduction NText,
		@param_JOL_FacultyActivities_Comment NText,
		@param_JOL_FacultyActivities_WorkRecord NText,
		@param_JOL_FacultyActivities_AddTime DateTime,
		@param_JOL_FacultyActivities_AddUser NVarChar(50),
		@param_JOL_FacultyActivities_VerifyState NVarChar(10),
		@param_JOL_FacultyActivities_VisitCounts Int
	)
AS
	INSERT INTO dbo.JOL_FacultyActivities
	(
		JOL_FacultyActivities_Faculty ,
		JOL_FacultyActivities_FacultyID ,
		JOL_FacultyActivities_Type ,
		JOL_FacultyActivities_Title ,
		JOL_FacultyActivities_Site ,
		JOL_FacultyActivities_StartTime ,
		JOL_FacultyActivities_EndTime ,
		JOL_FacultyActivities_Host ,
		JOL_FacultyActivities_Organizers ,
		JOL_FacultyActivities_Participants ,
		JOL_FacultyActivities_Introduction ,
		JOL_FacultyActivities_Comment ,
		JOL_FacultyActivities_WorkRecord ,
		JOL_FacultyActivities_AddTime ,
		JOL_FacultyActivities_AddUser ,
		JOL_FacultyActivities_VerifyState ,
		JOL_FacultyActivities_VisitCounts
	)
	VALUES
	(
		@param_JOL_FacultyActivities_Faculty ,
		@param_JOL_FacultyActivities_FacultyID ,
		@param_JOL_FacultyActivities_Type ,
		@param_JOL_FacultyActivities_Title ,
		@param_JOL_FacultyActivities_Site ,
		@param_JOL_FacultyActivities_StartTime ,
		@param_JOL_FacultyActivities_EndTime ,
		@param_JOL_FacultyActivities_Host ,
		@param_JOL_FacultyActivities_Organizers ,
		@param_JOL_FacultyActivities_Participants ,
		@param_JOL_FacultyActivities_Introduction ,
		@param_JOL_FacultyActivities_Comment ,
		@param_JOL_FacultyActivities_WorkRecord ,
		@param_JOL_FacultyActivities_AddTime ,
		@param_JOL_FacultyActivities_AddUser ,
		@param_JOL_FacultyActivities_VerifyState ,
		@param_JOL_FacultyActivities_VisitCounts
	)
GO
